Round 1: Technical

This round focused on assessing my technical skills and understanding of core concepts. The key areas covered included:

✅ Self-Introduction: A brief summary of my professional background and skills.

✅ SQL:

🔹 How to delete duplicate rows in a table using SQL.

🔹 Differences between ROW_NUMBER, RANK, and DENSE_RANK functions, along with examples for each.

🔹 Writing a basic query using the RANK function.

✅ GCP (Google Cloud Platform)

🔹 The use of DataProc in GCP.

🔹 BigQuery

🔹 Differences between external and internal tables in BigQuery.

🔹 Steps to create each type of table in BigQuery.

✅ Project Explanation: An overview of my current project, including architecture and implementation details.

Round 2: Technical

This round was more hands-on, focusing on problem-solving and project-related discussions. The topics included:

✅ Self-Introduction: A concise introduction highlighting my expertise.

✅ Project Discussion: Explained a logistics data warehouse management project from the course, detailing its objectives, challenges, and outcomes.

✅ Python Coding: Write a Python program to verify if a given number is prime.

✅ SQL Joins: Given a single column and two tables, determined the count for INNER JOIN, LEFT JOIN, and RIGHT JOIN.

✅ Airflow: Explained the role and functionality of executors in Airflow.

✅ BigQuery: Described how to create a partitioned table in BigQuery.

Round 3: HR

This round was conversational, focusing on personal and professional aspects. The topics included:

✅ Self-Introduction: Provided a brief overview of my background and career goals.

✅ Reason for Leaving Current Company: Discussed my motivations for seeking new opportunities.

✅ Salary Negotiation: Engaged in a discussion about expected compensation and benefits.